UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TEAG4qHBcrc8T1cH9cz0oduBapgbYBHCZDy4m57y9HU='
WHERE
key_id = 'efc63279f64f3efa57fa0c5fd48e724e304607ca9c79d7e8a5273885dd18fe28'
AND (
token = 'TEAG4qHBcrc8T1cH9cz0oduBapgbYBHCZDy4m57y9HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)