UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6kL1/qK0PV371XgXZOITxP/BPh50/P4eaIK050jOYnc=' 
WHERE 
  key_id = 'a94eef4eff9c596ac4c26500d183888cf7aed818df4cd335659fcde6051fb39c' 
  AND (
    token = '6kL1/qK0PV371XgXZOITxP/BPh50/P4eaIK050jOYnc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036