UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NmBnnlzApUhR069bEqOgsX2yZ3Uc3H1i+sQYTcsX57Q='
WHERE
key_id = '9a55d0c3a0eb781e59628a3ba27a31203b54baf52ab390cd68addef632bb5647'
AND (
token = 'NmBnnlzApUhR069bEqOgsX2yZ3Uc3H1i+sQYTcsX57Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)