UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsD7fGCrojOrQmOSMc+6oVNtA8oSeiy/TtPfut+5SnU='
WHERE
key_id = '3648df61598add4f3e917ffac491e049ad526c58588c6eac0b4db941a60830b1'
AND (
token = 'QsD7fGCrojOrQmOSMc+6oVNtA8oSeiy/TtPfut+5SnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)