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