UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgbBPHO3z8WqipL07cFUVEIuZdvaMGeBpM6olDf1G1k='
WHERE
key_id = '5138a159eb385db4e4cf3ce4e48a6b0696ab9b3632e6c7516f7bdec8f1690b24'
AND (
token = 'CgbBPHO3z8WqipL07cFUVEIuZdvaMGeBpM6olDf1G1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)