UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n82231Vz1gw0Z66AKGAz3vaw3Ui79ROl/KcPweNU8XY='
WHERE
key_id = 'b1ce665423e9209193b38f48e4e709e952235c5061c81d40d0b8abba5de497ec'
AND (
token = 'n82231Vz1gw0Z66AKGAz3vaw3Ui79ROl/KcPweNU8XY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)