UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iCcWbm/XPWjhs5gGPnh+/twsJvUXSNC41Kt0RCoDy/Q='
WHERE
key_id = '55bc293165cb1917c385a377e43a0477d8ff4555b75c53b6ec4bdae868936fdf'
AND (
token = 'iCcWbm/XPWjhs5gGPnh+/twsJvUXSNC41Kt0RCoDy/Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)