UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lfyD891GYE9OX7JJ7FW2X6l1grOcGGZKFTELEfNNy3I='
WHERE
key_id = '0ad59b9b08878fe64f67f0cfda5b93fa926a3c1037b47d982e737564ab534d1c'
AND (
token = 'lfyD891GYE9OX7JJ7FW2X6l1grOcGGZKFTELEfNNy3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)