UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n54FVIqvtI50DwEpJsTyTEsNJnGErh+PcPNfy8UkwIM='
WHERE
key_id = 'be9004a0618e08b4bfbee61cadcd3ae445bb8a8d18e122b713de778382c04375'
AND (
token = 'n54FVIqvtI50DwEpJsTyTEsNJnGErh+PcPNfy8UkwIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)