UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRLfY7VCL+mcQqf7Q0EB0XOvpdgmJIe5siZT11V9RwE='
WHERE
key_id = 'e8d9f2c0420f6bfac83510790f7c18274c2b685446f958625447f3269980d496'
AND (
token = 'zRLfY7VCL+mcQqf7Q0EB0XOvpdgmJIe5siZT11V9RwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)