UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRgw4/hxilsrl/LDyuYOots5T/xIQ4VGo5hBsOrTszE='
WHERE
key_id = 'c1237e15fe020c75f87ed2503b798efbb9dae7f4ee9d85f4b116fa5817371d09'
AND (
token = 'zRgw4/hxilsrl/LDyuYOots5T/xIQ4VGo5hBsOrTszE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)