UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1TeA5fGKJmfMPhqM8/XXnDsyXyz8uGZ0EcfsUz1S30U='
WHERE
key_id = 'd49aa07dcb08c99a1c8560c5bd8aeb9f2a0057029f076d7263b52be2280c50bb'
AND (
token = '1TeA5fGKJmfMPhqM8/XXnDsyXyz8uGZ0EcfsUz1S30U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)