UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h3YF1Gu+uLW7YrouL78F9Thg1Icr7ey36gatwOYr42Y='
WHERE
key_id = 'de0c89159292fd13f54aba88abfcff4e2843ce7471c8d65a3409e877d0dcecd2'
AND (
token = 'h3YF1Gu+uLW7YrouL78F9Thg1Icr7ey36gatwOYr42Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)