UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/miGVIpjXVb5dwT2PCWGOCzvS4PJVOj5Yk3f96XNZA4='
WHERE
key_id = '625fcd5e9478c07082e28b6f5bc309d4a92d4ef4ea47f3a5f45a3bba6696be8a'
AND (
token = '/miGVIpjXVb5dwT2PCWGOCzvS4PJVOj5Yk3f96XNZA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)