UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qE/i42nKoXGTYhD5f4qUm0oLwk/TMuFr5Z/lfnO4SLw=' 
WHERE 
  key_id = 'd8d5b87fd08026cff2e7317c3ec37cc18186d015f8dcec93c5f7b66ec4866e74' 
  AND (
    token = 'qE/i42nKoXGTYhD5f4qUm0oLwk/TMuFr5Z/lfnO4SLw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00093