UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SFnj6cKaRBxaELDhX0CRdAA0aaKH5mInvSFJ7nMoWrw='
WHERE
key_id = '53747413e3f88d521891fd9dd0366808f27d5ecebd8f13225f2564e9568b8650'
AND (
token = 'SFnj6cKaRBxaELDhX0CRdAA0aaKH5mInvSFJ7nMoWrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)