UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0VJM+ES07kOQ8t+7BLJTPXEuRov3B8JSybSRs2NuiP0='
WHERE
key_id = '27e63e2b63683a13841865f2a84c8ced1acefce067beaea90ee28c97736b6c0c'
AND (
token = '0VJM+ES07kOQ8t+7BLJTPXEuRov3B8JSybSRs2NuiP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)