UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFl5YRH7Y9I7n6q1w7OlazaazH0eVoGeDS8j0Zt46/8='
WHERE
key_id = 'cb0feb89986ef81d69c4f8ff8693ebe363634692802becf1ac01341ef0121707'
AND (
token = 'HFl5YRH7Y9I7n6q1w7OlazaazH0eVoGeDS8j0Zt46/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)