UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z0E07tfCda40+sFziSfB1AOP3bN4vPmGhx6Q4BKDCYs='
WHERE
key_id = '1c9770dc03943e973d5f7ec5d336b743803afc2ed660ac0107986aaab2238eda'
AND (
token = 'z0E07tfCda40+sFziSfB1AOP3bN4vPmGhx6Q4BKDCYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)