UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7vNZ+XNNC7+7zhuGU3hAFn3M/Ci/Z/WkXgtAkFhGicg=' 
WHERE 
  key_id = 'ae11f8f3cce1374080c460f9ed89f1360759ee7c1c9179a650c8cc5e5ff79b6a' 
  AND (
    token = '7vNZ+XNNC7+7zhuGU3hAFn3M/Ci/Z/WkXgtAkFhGicg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031