UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gh6XT7XCkrYQ2lDTFisCU1uQI9752NEFY/Z6CPC4WPc='
WHERE
key_id = 'd64e5704445592ef6cfaa351a2d6f5b9559811741dec90bcd1d527380c3c9888'
AND (
token = 'Gh6XT7XCkrYQ2lDTFisCU1uQI9752NEFY/Z6CPC4WPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)