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