UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T0BM9VkGVIyUxwy8AJEJG0FakoX/kNQW8S9HkoQUqxM='
WHERE
key_id = 'e485b16de1785ab398dec72305ce903e03b92aae2e60ef7856d08d2a65ea4841'
AND (
token = 'T0BM9VkGVIyUxwy8AJEJG0FakoX/kNQW8S9HkoQUqxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)