UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g/EBBW7abKHmLG6erOaNdKE8kJQ27H7mqLdjzdnASWM='
WHERE
key_id = 'f832400fcbd6a5b56e8b972f6a1a4e5a0495e50636fe7f035b402117a29d546e'
AND (
token = 'g/EBBW7abKHmLG6erOaNdKE8kJQ27H7mqLdjzdnASWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)