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