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