UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fWH6VFDGcjB6l1i7PI7KYtSCx1QwIwmOn6mRS8dsKQ4='
WHERE
key_id = '0badf23b7a58d1fb7aa30e57fec243772f0f2f6b3f88717576454ede74e4af22'
AND (
token = 'fWH6VFDGcjB6l1i7PI7KYtSCx1QwIwmOn6mRS8dsKQ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)