UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SxUd0utGx3MOvHpF2ivOkEcvzwv9pcTbl8yDV7Lr5q0='
WHERE
key_id = '40a59cf6f588d6e0e26897205577636ed75385a0fc162be8c45882c978ded0b3'
AND (
token = 'SxUd0utGx3MOvHpF2ivOkEcvzwv9pcTbl8yDV7Lr5q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)