UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PgayO1K6eqYxA/qytPi1YMt3AahSGDuu2809MQ3wN8Y='
WHERE
key_id = 'a8c6f513c51e11be1e1522b03659d395118f6fb0b083a97e5202d5beaa37f325'
AND (
token = 'PgayO1K6eqYxA/qytPi1YMt3AahSGDuu2809MQ3wN8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)