UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F1m0EUB3qrnk668uqAmWU7HjeL49ptraEejIDi1rCoQ='
WHERE
key_id = 'a6729e76fac9e19aca48c83e5e4a84bfbeb376cb6df9fbe0607d64a5c159ca15'
AND (
token = 'F1m0EUB3qrnk668uqAmWU7HjeL49ptraEejIDi1rCoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)