UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B30i067ziDNK/SkgfwMFfXKNHbKfOIixnrO6co2zMZo='
WHERE
key_id = 'a46ce7c31c6084e73a7e7b36bc63a784b977c3a163d4774ef276d82cb058792f'
AND (
token = 'B30i067ziDNK/SkgfwMFfXKNHbKfOIixnrO6co2zMZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)