UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vQqMbgJbDbr8n2USs1UGvhZOo5hbhftYV8wODb6Q9Bw='
WHERE
key_id = '7fdf4c52a0ebedf6f57096274cf2251faa1e5e8a798e372a95d9e3c53a40cddd'
AND (
token = 'vQqMbgJbDbr8n2USs1UGvhZOo5hbhftYV8wODb6Q9Bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)