UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MsObCNXil2FCej7gLgr0sR+9UkKsQWdrDGF21FoB+GE=' 
WHERE 
  key_id = '45d2a26b9dd4230c89076e81ed0e5adddf0a24ffe23a4f0c34a0832ef5958cd4' 
  AND (
    token = 'MsObCNXil2FCej7gLgr0sR+9UkKsQWdrDGF21FoB+GE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030