UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHXyiz1Gm9fETyqDkMPfdJrxM6ghWtXDWLUNoRi/heU='
WHERE
key_id = '9defe40f5a70670b97700b96f6481a85ed8cfaf0d8efab5031b2638149755e89'
AND (
token = 'NHXyiz1Gm9fETyqDkMPfdJrxM6ghWtXDWLUNoRi/heU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)