UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hai5s8eXd8XoUnwW5xZqioIvvIkJXiUvnut4KaftRKg='
WHERE
key_id = '89dcb5cad46920970a01d811e81df0ae99c13e41b51b9330f9ddb073e08870f1'
AND (
token = 'hai5s8eXd8XoUnwW5xZqioIvvIkJXiUvnut4KaftRKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)