UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6wq7jWkINrrEay4z3n0o4oUyDoVVv82WzqcwbaaKoa8='
WHERE
key_id = 'd16b605545ac4a5d1f28ce6b12cf8981c9fec2a55bb15cde3d066f57b5988a5b'
AND (
token = '6wq7jWkINrrEay4z3n0o4oUyDoVVv82WzqcwbaaKoa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)