UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/Uz4dY7F+9xGjDB9PIGR0yW2/qNQGTD3qDQ/f/xqEIs=' 
WHERE 
  key_id = '504540d8bf8f020aae9d76f5ea5de26a268685e0a2f4a0e420c759f4d0433f30' 
  AND (
    token = '/Uz4dY7F+9xGjDB9PIGR0yW2/qNQGTD3qDQ/f/xqEIs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032