UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cIqM+DcESDlhfJSP5Mht4+Y/PdMGMIT8oo0ruuEUAHU='
WHERE
key_id = 'f3fcfb419be206caa9af8b9398f8063befeae2accbdfb3b8bb05f5a92ec58258'
AND (
token = 'cIqM+DcESDlhfJSP5Mht4+Y/PdMGMIT8oo0ruuEUAHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)